Styles
The same standard Styles are used in Excel, however, if you want to create a new style in order to change the format of how the numbers are displayed, see the example that follows.
Creating a Custom Style
The following example was created in the Excel 2010 Version.
On the Home Tab, click on the new style sheet.
Select New Cell Style
A new style window will appear, click Format.
The format page will then display, click Custom.
Finally, under Type, enter the custom formatting. This example will be formatting for Millions. (#,,)
Click OK.
Type in a Style Name and click OK.
Now that a new style sheet has been created in Excel, it can be assigned to a Quick view.
This is the Quick View before the formatting:
To add the formatting, click on the Edit Quick View Options in the Quick View Tab on the right side of the screen.
This is the Quick View after the update: